package com.atguigu.springbootcrud.Dao;

import com.atguigu.springbootcrud.pojo.emp;
import com.atguigu.springbootcrud.vo.tjQuery;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author lhl
 * @create 2019-12-27 22:48
 */
@Mapper
public interface crudMapper_emp extends BaseMapper<emp> {
    @Select("select em.emp_id,em.emp_name,em.email,em.gender,dep.dept_id,dep.dept_name from ssm_crud.tbl_emp em join ssm_crud.tbl_dept dep on dep.dept_id=em.d_id")
    List<tjQuery> findAll();
}
